In this video we will learn why not by judge and how to drop a chart.
A pie chart is useful when you want to show relative proportions or contributions to a whole pie chart
can use only one data cities pie charts are most effective with a small number of data points.
For example you must have seen such kind of pie chart showing the votes or seats won by different political
parties during elections.
Generally a pie chart should not use more than 5 or 6 data points that is slices a pie chart with too
many data points can be very difficult to interpret in this simple example here I have the unit sort
of different product in this table and I am creating a pie chart showing the contribution of each of
these product to the total.
So you can see the largest contribution is this orange slice which represents banks which has a value
of one thousand eighty two.
It is very difficult to read this pie chart because it has missing data labels.
I do not know what is the contribution of each individual product to the total.
So I would like to add the data labels but before that let me tell you how to create this chart first.
I believe this selected table
go to insert recommended chart and you can see that Excel is itself recommending this pie chart.
If you do not find the pie chart option in the recommended charts option you can always go to the this
symbol which is represented by each chart and you can select a pie chart did so I have this pie chart.
I want to add data labels.
I click on this plus button and add data labels.
So now you can see that it is by default coming at the center.
You have the option of changing the position of these data labels.
If you wanted to come outside you can select out today or if you want it as a data cloud you can use
that.
But these are still numerical values if you would like to see the percentage contribution of each product
you can go to the data series formatting options and instead of value here you can put percentage so
you can see forty eight percent of the total tables was contributed by banks product.
If you want multiple data labels like if you want category name and value and percentage you can add
all of those all these three information will be shown.
Separated by commas
if we want to highlight any particular product.
So for example I want to highlight that only 8 percent of my sales is contributed by showed.
You can select that particular slice by double living on it and dragging and dropping it somewhere else.
So this is called exploding the pie chart.
You can explore individual slices on more than one slices also.
This draws attention of the viewers towards this particular contributor to this place.
Now let us go to the pie chart options and let us look what are the different types of pie charts we
can draw.
So the first one we have already drawn which is a simple pie chart.
The second one is a 3D pie.
It is exactly similar to the previous one just that it has a third dimension of giving the height to
that pie which is really useless but still to make it more visually appealing.
You can probably do the 3D by J then these next two options are by way of pie and the second one is
bought off by the payoff pie and board of pie chart enables you to display a secondary chart that provide
more detail for one of the pie slices.
For example
if I have data like this the fourth contributor which was others if it has four separate subcategories.
If I create a single pie chart of all seven of these pages I will be very cluttered and I also want
to emphasize that the last four are not a separate product for us.
We consider them as a single others product.
It has just four subcategories to it.
In that case what I can do is I can blow it up first by jacket which will have both products.
Short pants jeans and others and these others by will be exploded into another pie and it will have
four other slices.
So the read by jug or the bar chart can clearly provide the additional breakdown of the others contributed.
So how do I draw this.
Let me delete this one first.
Now select this table and select these by your pie chart.
You can see that your by jug is not in the recommended Taj option.
So I'll go to all jarred by analogy old lady by your Bijan you can see that instead of last four subcategories
which were to be combined.
It has added only last three categories.
The others socks category is part of the main pie.
Instead of being part of the secondary body to correct this we will select debate.
We will go to the data format data cities options in this third option.
Since we want the last four subcategories to be part of the second debate we can select disposition
option and tailored that the last four values in my table should belong to the second debate.
You can see this is a chart that we actually wanted.
There are other options of splitting the cities also.
For example if you select value here you can tell it below which value you want to prosper.
The places from primary just to secondary charge.
So for example if I put 4000 here all the individual categories which have value less than 4000 will
be part of the candy jar and which have more than 4000 value will be part of the primary job.
Third is giving the same result.
Similarly there is a percentage value which you can give.
Again if I put 20 percent it cleared set out so probably nearly 15 percent will give me did a job which
I intend to draw.
There it is.
And the last option to do Broadhead is custom where I can select a particular by a particular slice
of a pie chart and tell it to go to primary plot or the secondary plot
similar is the board of pie chart.
If I select this one and two integer type 2 board of Bajor only that the secondary by judge is now a
bar chart and the contribution of each subcategory is the height of this.
So it is Lagos tagged by column and the height of each subcategory is telling you the contribution of
each subcategory.
Again remember that up a pie chart should have read the labels so we will select data levels to be our
time or best fit whichever you prefer.
If you want it to be percentages you can always select those and change the label options to percentage
the last option in the pie chart is a doughnut chart
are donor charges similar to a pie chart but it has two differences.
One is that it has a hole in the middle.
And second is that it can display more than once it is already done.
In this example I have two data series one for the year 2000 A.D. and the other four year 2019.
And I want to plot the contribution of my product to the total tables in these two years.
How is the contribution changing for each product to instead of creating two different pie charts.
I have created a single donor chart you can see that the inner circle is giving me the contribution
or Product of 2000 A.D. here and the older one is giving the contribution of 2019.
And from this pie you can see the contribution of sharks has increased for balance.
I'm not really sure because the base line has moved so I'm not really sure whether it has increased
or not.
Probably if I add data levels I'll be able to compare.
Same goes with the other categories.
So although this looks visually appealing it is very difficult to compare the contribution of product
using a donor chart and instead of this stat column chart will be a much better choice.
So let us see how to draw this one well the league selected it will go to insert and you can see that
by default Excel is telling you the column chart instead of this we are drawing a donor chart.
So this is a donor chart.
Okay here's a donor chart you can add data levels again by clicking this plus sign to click on this.
Do you have your data level.
You can position them change people using all these data labels to make them more readable
however since you already have a lot of categories.
This chart is going to be cluttered and there is no way this will look good in the formatting options.
You can change the weight of these things you can do that by clicking any of these and opening opening
day formatting options and then you can reduce the donut hole size to make these rings ticker.
You can also change these numbers to percentages by similarly going to the label options and changing
values to percentages.
So although this type of charge would be used very sparingly we have covered the donut chart just so
that do you know how to draw an.